package com.example.demo.mapper;

import com.example.demo.pojo.Jilue;
import com.example.demo.pojo.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface NumberMapper {

    @Select("select * from JiLue")
    List<User> getAllNumbers();

    @Select("select * from JiLue where role = '学生'")
    List<User> getAllRole();

    @Select("select * from JiLue where role = '学生' and status = '已解除'")
    List<User> getAllStatus();

    @Select("select * from JiLue where role = '教授' and status = '已解除'")
    List<User> getTeacherStatus();

    @Select("select * from JiLue where info = '警告'")
    List<User> getWarn();

    @Select("select * from JiLue where info = '严重警告'")
    List<User> getSeriouWarn();

    @Select("select * from JiLue where info = '留校察看'")
    List<User> getSeekWarn();

    @Select("select * from JiLue where info = '记过'")
    List<User> getJiGuoWarn();

    @Select("select * from JiLue where info = '开除学籍'")
    List<User> getOutWarn();

    @Select("select created_at from JiLue ")
    List<Jilue> getUpdateTime();

}
